Import Rates from Excel
OBJECTIVE
The Import Rates from Excel option is used to transfer multiple hourly rates to maestro* from an Excel file.
This file may have been created manually or by exporting hourly rates from maestro*.
This option can be very useful for updating the hourly rates file whose use will soon become mandatory.
Steps
Import rates
- Click the Import Rates from Excel icon.
- Select a file by selecting its location in the window and clicking Accept.
The data is displayed on the screen.
- Click Validate the Table.
The system displays the incorrect data in red to ensure these values exist: Employee, trade code, region and union code.
The Hourly Rate and Sector fields are mandatory.
The data can be corrected on the screen and reconfirmed by clicking Validate the Table again.
- Click Apply to import the hourly rates.
- Click Exit to leave the import screen.
See also